Đặt vé xe buýt trực tuyến bằng PHP / MySQLi

1 <?php
2 include(
'db.php');
3 function createRandomPassword() {
4     $chars =
"abcdefghijkmnopqrstuvwxyz023456789";
5     srand((
double)microtime()*1000000);
6     $i =
0;
7     $pass =
'' ;
8     
while ($i <= 7) {
9         $num = rand() %
33;
10         $tmp = substr($chars, $num,
1);
11         $pass = $pass . $tmp;
12         $i++;
13     }
14     
return $pass;
15 }
16 $confirmation = createRandomPassword();
17 $fname=$_POST[
'fname'];
18 $qty=$_POST[
'qty'];
19 $lname=$_POST[
'lname'];
20 $busnum=$_POST[
'busnum'];
21 $setnum=$_POST[
'setnum'];
22 $date=$_POST[
'date'];
23 $contact=$_POST[
'contact'];
24 $address=$_POST[
'address'];
25 $result = mysqli_query($conn,
"SELECT * FROM route WHERE id='$busnum'");
26 while
($row = mysqli_fetch_array($result))
27     {
28     $price=$row[
'price'];
29     }
30     $payable=$qty*$price;
31 mysqli_query($conn,
"INSERT INTO customer (fname, lname, address, contact, bus, transactionum, payable, setnumber)
32 VALUES ('$fname', '$lname', '$address', '$contact', '$busnum', '$confirmation','$payable','$setnum')"
);
33 mysqli_query($conn,
"INSERT INTO reserve (date, bus, seat_reserve, transactionnum, seat)
34 VALUES ('$date', '$busnum', '$qty', '$confirmation','$setnum')"
);
35 header(
"location: print.php?id=$confirmation&setnum=$setnum");
36 ?>


Gõ tìm kiếm nhanh...